IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'CGO_Game')
                    AND OBJECTPROPERTY(id, N'IsTable') = 1 ) 
  BEGIN
    DROP TABLE dbo.CGO_Game
  END
  
CREATE TABLE [dbo].[CGO_Game]
(
[GameID] [int] NOT NULL IDENTITY(1, 1),
[PortalID] [int] NULL,
[PackageName] [nvarchar] (128) NOT NULL,
[Name] [nvarchar] (100) NOT NULL,
[Description] [ntext] NULL,
[ImageURL] [nvarchar] (100) NULL,
[ImageType] [nvarchar] (1) NULL,
[ImageWidth] [int] NULL,
[ImageHeight] [int] NULL,
[GameTabID] [int] NULL,
[Status] [int] NOT NULL,
[Category] [int] NULL,
[ImageDisplay] [bit] NOT NULL,
[CreatedByID] [int] NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[LastUpdatedID] [int] NOT NULL,
[LastUpdateDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CGO_Game] ADD CONSTRAINT [PK_CGO_Game] PRIMARY KEY CLUSTERED  ([GameID]) ON [PRIMARY]
GO